I note that none the answers are specific to MySQL, which does have its own semantics in some areas. I would also like to see a decent write-up. – Lightness ... ... <看更多>

To understand the reason behind slowness of your current query, you need to understand the Nested Loop Join algorithm used by MySQL. ... <看更多>